<?php
defined( '_JEXEC' );
echo '<div class="componentheading">Players</div>';

jimport('joomla.application.helper');
require_once( JApplicationHelper::getPath( 'html' ) );
JTable::addIncludePath(JPATH_ADMINISTRATOR.DS.
'components'.DS.$option.DS.'tables');
switch($task)
{
case 'view':
showPublishedPlayers($option);
break;
default:
showPublishedPlayers($option);
break;
}
function showPublishedPlayers($option)
{
$db =& JFactory::getDBO();
$query = "SELECT * FROM #__statzone_players WHERE
showplayer = '1'";
$db->setQuery( $query );
$rows = $db->loadObjectList();
if ($db->getErrorNum())
{
echo $db->stderr();
return false;
}
	HTML_players::showPlayers($rows, $option,$pageNav);
}

?>